﻿using System.Linq;
using System.Text;
using System.Diagnostics;
using System.Runtime.Serialization;
using System.Collections;
using System.Data;
using System.ComponentModel;
using System.Data.OracleClient;
using WPFExcelReport.Helpers;
using WPFExcelReport.Controls;
using System;
using System.Collections.Generic;
namespace WPFExcelReport
{
    public partial class VKDANSP
    {
        public void UPDATEKDNUMBER(Dictionary<string, object> pm)
        {
            dwData = TBMain.NewRow();
            dwData["KDSMANDANT"] = app.Mandant;
            dwData["KDSKUNDNR"] = pm["KUNDNR"].ToString();
            dwData["KDSANSPNA"] = pm["NKUNDNR"].ToString();
            UpdateKDANSP(dwData,app.company, 2);
        }
    }

    public partial class VKDANSP
    {

        public string KDSMANDANT { get { if (dwMaster == null) return ""; return dwMaster["KDSMANDANT"].ToString(); } set { if (dwMaster == null) return; dwMaster["KDSMANDANT"] = value; OnPropertyChanged("KDSMANDANT", value); } } //lENGth 2
        public string KDSKUNDNR { get { if (dwMaster == null) return ""; return dwMaster["KDSKUNDNR"].ToString(); } set { if (dwMaster == null) return; dwMaster["KDSKUNDNR"] = value; OnPropertyChanged("KDSKUNDNR", value); } } //lENGth 8
        public string KDSANSPNA { get { if (dwMaster == null) return ""; return dwMaster["KDSANSPNA"].ToString(); } set { if (dwMaster == null) return; dwMaster["KDSANSPNA"] = value; OnPropertyChanged("KDSANSPNA", value); } } //lENGth 8
        public string KDSANSPNAME { get { if (dwMaster == null) return ""; return dwMaster["KDSANSPNAME"].ToString(); } set { if (dwMaster == null) return; dwMaster["KDSANSPNAME"] = value; OnPropertyChanged("KDSANSPNAME", value); } } //lENGth 30
        public string KDSANREDE { get { if (dwMaster == null) return ""; return dwMaster["KDSANREDE"].ToString(); } set { if (dwMaster == null) return; dwMaster["KDSANREDE"] = value; OnPropertyChanged("KDSANREDE", value); } } //lENGth 1
        public string KDSNAME1 { get { if (dwMaster == null) return ""; return dwMaster["KDSNAME1"].ToString(); } set { if (dwMaster == null) return; dwMaster["KDSNAME1"] = value; OnPropertyChanged("KDSNAME1", value); } } //lENGth 40
        public string KDSVB { get { if (dwMaster == null) return ""; return dwMaster["KDSVB"].ToString(); } set { if (dwMaster == null) return; dwMaster["KDSVB"] = value; OnPropertyChanged("KDSVB", value); } } //lENGth 3
        public string KDSVG { get { if (dwMaster == null) return ""; return dwMaster["KDSVG"].ToString(); } set { if (dwMaster == null) return; dwMaster["KDSVG"] = value; OnPropertyChanged("KDSVG", value); } } //lENGth 3
        public string KDSFKT { get { if (dwMaster == null) return ""; return dwMaster["KDSFKT"].ToString(); } set { if (dwMaster == null) return; dwMaster["KDSFKT"] = value; OnPropertyChanged("KDSFKT", value); } } //lENGth 50
        public double KDSANFDAT { get { if (dwMaster == null) return 0.0; return Convert.ToDouble(dwMaster["KDSANFDAT"].ToString()); } set { if (dwMaster == null) return; dwMaster["KDSANFDAT"] = value; OnPropertyChanged("KDSANFDAT", value); } } //lENGth 0
        public double KDSENDDAT { get { if (dwMaster == null) return 0.0; return Convert.ToDouble(dwMaster["KDSENDDAT"].ToString()); } set { if (dwMaster == null) return; dwMaster["KDSENDDAT"] = value; OnPropertyChanged("KDSENDDAT", value); } } //lENGth 0
        public string KDSZUSADRSL { get { if (dwMaster == null) return ""; return dwMaster["KDSZUSADRSL"].ToString(); } set { if (dwMaster == null) return; dwMaster["KDSZUSADRSL"] = value; OnPropertyChanged("KDSZUSADRSL", value); } } //lENGth 8
        public string KDSTEL { get { if (dwMaster == null) return ""; return dwMaster["KDSTEL"].ToString(); } set { if (dwMaster == null) return; dwMaster["KDSTEL"] = value; OnPropertyChanged("KDSTEL", value); } } //lENGth 20
        public string KDSFAX { get { if (dwMaster == null) return ""; return dwMaster["KDSFAX"].ToString(); } set { if (dwMaster == null) return; dwMaster["KDSFAX"] = value; OnPropertyChanged("KDSFAX", value); } } //lENGth 20
        public double KDSURLVDAT { get { if (dwMaster == null) return 0.0; return Convert.ToDouble(dwMaster["KDSURLVDAT"].ToString()); } set { if (dwMaster == null) return; dwMaster["KDSURLVDAT"] = value; OnPropertyChanged("KDSURLVDAT", value); } } //lENGth 0
        public double KDSURLBDAT { get { if (dwMaster == null) return 0.0; return Convert.ToDouble(dwMaster["KDSURLBDAT"].ToString()); } set { if (dwMaster == null) return; dwMaster["KDSURLBDAT"] = value; OnPropertyChanged("KDSURLBDAT", value); } } //lENGth 0
        public string KDSVERTR { get { if (dwMaster == null) return ""; return dwMaster["KDSVERTR"].ToString(); } set { if (dwMaster == null) return; dwMaster["KDSVERTR"] = value; OnPropertyChanged("KDSVERTR", value); } } //lENGth 8
        public string KDSSACHB { get { if (dwMaster == null) return ""; return dwMaster["KDSSACHB"].ToString(); } set { if (dwMaster == null) return; dwMaster["KDSSACHB"] = value; OnPropertyChanged("KDSSACHB", value); } } //lENGth 8
        public double KDSWVDAT { get { if (dwMaster == null) return 0.0; return Convert.ToDouble(dwMaster["KDSWVDAT"].ToString()); } set { if (dwMaster == null) return; dwMaster["KDSWVDAT"] = value; OnPropertyChanged("KDSWVDAT", value); } } //lENGth 0
        public string KDSWVGRUND { get { if (dwMaster == null) return ""; return dwMaster["KDSWVGRUND"].ToString(); } set { if (dwMaster == null) return; dwMaster["KDSWVGRUND"] = value; OnPropertyChanged("KDSWVGRUND", value); } } //lENGth 25
        public string KDSGEBJJ { get { if (dwMaster == null) return ""; return dwMaster["KDSGEBJJ"].ToString(); } set { if (dwMaster == null) return; dwMaster["KDSGEBJJ"] = value; OnPropertyChanged("KDSGEBJJ", value); } } //lENGth 4
        public string KDSGEBMM { get { if (dwMaster == null) return ""; return dwMaster["KDSGEBMM"].ToString(); } set { if (dwMaster == null) return; dwMaster["KDSGEBMM"] = value; OnPropertyChanged("KDSGEBMM", value); } } //lENGth 2
        public string KDSGEBTT { get { if (dwMaster == null) return ""; return dwMaster["KDSGEBTT"].ToString(); } set { if (dwMaster == null) return; dwMaster["KDSGEBTT"] = value; OnPropertyChanged("KDSGEBTT", value); } } //lENGth 2
        public string KDSVIPGRP { get { if (dwMaster == null) return ""; return dwMaster["KDSVIPGRP"].ToString(); } set { if (dwMaster == null) return; dwMaster["KDSVIPGRP"] = value; OnPropertyChanged("KDSVIPGRP", value); } } //lENGth 8
        public string KDSPRAESTYP { get { if (dwMaster == null) return ""; return dwMaster["KDSPRAESTYP"].ToString(); } set { if (dwMaster == null) return; dwMaster["KDSPRAESTYP"] = value; OnPropertyChanged("KDSPRAESTYP", value); } } //lENGth 3
        public string KDSWEIHKKZ { get { if (dwMaster == null) return ""; return dwMaster["KDSWEIHKKZ"].ToString(); } set { if (dwMaster == null) return; dwMaster["KDSWEIHKKZ"] = value; OnPropertyChanged("KDSWEIHKKZ", value); } } //lENGth 1
        public string KDSSPERRPJ { get { if (dwMaster == null) return ""; return dwMaster["KDSSPERRPJ"].ToString(); } set { if (dwMaster == null) return; dwMaster["KDSSPERRPJ"] = value; OnPropertyChanged("KDSSPERRPJ", value); } } //lENGth 1
        public string KDSMAILADR { get { if (dwMaster == null) return ""; return dwMaster["KDSMAILADR"].ToString(); } set { if (dwMaster == null) return; dwMaster["KDSMAILADR"] = value; OnPropertyChanged("KDSMAILADR", value); } } //lENGth 100
        public string KDSPASSW { get { if (dwMaster == null) return ""; return dwMaster["KDSPASSW"].ToString(); } set { if (dwMaster == null) return; dwMaster["KDSPASSW"] = value; OnPropertyChanged("KDSPASSW", value); } } //lENGth 20
        public string KDSFILLER { get { if (dwMaster == null) return ""; return dwMaster["KDSFILLER"].ToString(); } set { if (dwMaster == null) return; dwMaster["KDSFILLER"] = value; OnPropertyChanged("KDSFILLER", value); } } //lENGth 79
        public double KDSAENDZL { get { if (dwMaster == null) return 0.0; return Convert.ToDouble(dwMaster["KDSAENDZL"].ToString()); } set { if (dwMaster == null) return; dwMaster["KDSAENDZL"] = value; OnPropertyChanged("KDSAENDZL", value); } } //lENGth 0
        public string KDSAENDBEN { get { if (dwMaster == null) return ""; return dwMaster["KDSAENDBEN"].ToString(); } set { if (dwMaster == null) return; dwMaster["KDSAENDBEN"] = value; OnPropertyChanged("KDSAENDBEN", value); } } //lENGth 8
        public double KDSAENDDAT { get { if (dwMaster == null) return 0.0; return Convert.ToDouble(dwMaster["KDSAENDDAT"].ToString()); } set { if (dwMaster == null) return; dwMaster["KDSAENDDAT"] = value; OnPropertyChanged("KDSAENDDAT", value); } } //lENGth 0
        public string KDSNEUBEN { get { if (dwMaster == null) return ""; return dwMaster["KDSNEUBEN"].ToString(); } set { if (dwMaster == null) return; dwMaster["KDSNEUBEN"] = value; OnPropertyChanged("KDSNEUBEN", value); } } //lENGth 8
        public double KDSNEUDAT { get { if (dwMaster == null) return 0.0; return Convert.ToDouble(dwMaster["KDSNEUDAT"].ToString()); } set { if (dwMaster == null) return; dwMaster["KDSNEUDAT"] = value; OnPropertyChanged("KDSNEUDAT", value); } } //lENGth 0

    }
}
